﻿Imports System
Imports System.Data
Imports System.Data.SqlTypes
Imports System.Data.SqlClient


Public Class WfProjectTimingTask
    Public Const Table_Project_Timing_Task As String = "project_timing_task"

    '定义全局数据库连接对象
    Private conn As SqlConnection

    '定义全局数据库连接适配器
    Private dsCommand_WfProjectTimingTask As SqlDataAdapter

    '定义查询命令
    Private GetWfProjectTimingTaskInfoCommand As SqlCommand

    '定义事务
    Private ts As SqlTransaction


    '构造函数
    Public Sub New(ByVal DbConnection As SqlConnection, ByRef trans As SqlTransaction)
        MyBase.New()
        conn = DbConnection


        '实例化适配器
        dsCommand_WfProjectTimingTask = New SqlDataAdapter()

        '打开数据库连接
        If conn.State = ConnectionState.Closed Then
            conn.Open()
        End If

        '引用外部事务
        ts = trans

        '填充适配器
        GetWfProjectTimingTaskInfo("null")
    End Sub

    '获定时任务信息
    Public Function GetWfProjectTimingTaskInfo(ByVal strSQL_Condition_WfProjectTimingTask As String) As DataSet

    End Function


    '更新定时任务信息
    Public Function UpdateWfProjectTimingTask(ByVal WfProjectTimingTaskSet As DataSet)

    End Function
End Class
